CREATE TABLE [dbo].[u_f1_06_areasexteriores]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[idCui] [int] NOT NULL,
[numIdentific] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[idTipoAreaExterior] [int] NULL,
[idTermPiso] [int] NULL,
[idEstado] [int] NULL,
[superficie] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_f1_06_areasexteriores] ADD CONSTRAINT [PK_u_f1_06_areasexteriores] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_f1_06_areasexteriores] WITH NOCHECK ADD CONSTRAINT [FK_u_f1_06_areasexteriores_u_cui] FOREIGN KEY ([idCui]) REFERENCES [dbo].[u_cui] ([Id]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[u_f1_06_areasexteriores] WITH NOCHECK ADD CONSTRAINT [FK_u_f1_06_areasexteriores_u_tp_estado] FOREIGN KEY ([idEstado]) REFERENCES [dbo].[u_tp_estado] ([Id]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[u_f1_06_areasexteriores] WITH NOCHECK ADD CONSTRAINT [FK_u_f1_06_areasexteriores_u_tp_areas_exteriores] FOREIGN KEY ([idTipoAreaExterior]) REFERENCES [dbo].[u_tp_areas_exteriores] ([Id]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[u_f1_06_areasexteriores] NOCHECK CONSTRAINT [FK_u_f1_06_areasexteriores_u_cui]
GO
ALTER TABLE [dbo].[u_f1_06_areasexteriores] NOCHECK CONSTRAINT [FK_u_f1_06_areasexteriores_u_tp_estado]
GO
ALTER TABLE [dbo].[u_f1_06_areasexteriores] NOCHECK CONSTRAINT [FK_u_f1_06_areasexteriores_u_tp_areas_exteriores]
GO
